﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MusicOnSpace.DTO
{
    public class PlaylistDTO
    {
        List<PlaylistDTO> PlaylistDTOList = new List<PlaylistDTO>();
        dataProvider dp = new dataProvider();

        public void InsertPlaylistDTO(string id, string name, string genre, string singname, string descript)
        {
            string command = "Insert into PlaylistDTO (aId, aName, aGenre, aCoverUrl, singName, Description) values (" + id + "," + name + "," + genre + "," + singname + "," + descript + ")";

            dp.ExeCuteNonQuery(command);
        }

        public void DeletePlaylistDTO(string id)
        {
            string command = "";
            dp.ExeCuteNonQuery(command);
        }

        public void PlaylistDTOSearch(string name)
        {
            string command = "Select * from PlaylistDTO where name like 'N" + name + "'";
            dp.ExeCuteNonQuery(command);
        }

        public void GetPlaylistDTOber()
        {

        }

        public List<PlaylistDTO> AddPlaylistDTO()
        {
            //SqlCommand cmd = new SqlCommand ("Insert into PlaylistDTOber (
            return PlaylistDTOList;
        }
    }
}